A Realistic Data Warehouse Project: An Integration of Microsoft Access® and Microsoft Excel® Advanced Features and Skills
نویسندگان
چکیده
Business intelligence derived from data warehousing and data mining has become one of the most strategic management tools today, providing organizations with long-term competitive advantages. Business school curriculums and popular database textbooks cover data warehousing, but the examples and problem sets typically are small and unrealistic. The purpose of this paper is to provide an overview of how to construct a realistic data warehouse using numerous advanced features available in Microsoft Access and Microsoft Excel.
منابع مشابه
Tutorial Review: Simulation of Oscillating Chemical Reactions Using Microsoft Excel Macros
Oscillating reactions are one of the most interesting topics in chemistry and analytical chemistry. Fluctuations in concentrations of one the reacting species (usually a reaction intermediate) create an oscillating chemical reaction. In oscillating systems, the reaction is far from thermodynamic equilibrium. In these systems, at least one autocatalytic step is required. Developing an instinctiv...
متن کاملAN EFFECTIVE METHOD FOR SIMULTANEOUSLY CONSIDERING TIME-COST TRADE-OFF AND CONSTRAINT RESOURCE SCHEDULING USING NONLINEAR INTEGER FRAMEWORK
Critical Path Method (CPM) is one of the most popular techniques used by construction practitioners for construction project scheduling since the 1950s. Despite its popularity, CPM has a major shortcoming, as it is schedule based on two impractical acceptance that the project deadline is not bounded and that resources are unlimited. The analytical competency and computing capability of CPM thus...
متن کاملبررسی میزان رضایت پرستاران بخش مراقبت ویژه نوزادان از آموزش دوره های هفتگانه گواهینامه جهانی کاربری کامپیوتر
Introduction & Objective: Development of information technology has a significant effect on improvement Delivered public services and cooperation with international changes and generally better life. International Computer Driving License (ICDL) is performed in 70 countries now and includes: Information technology, windows XP, internet, Microsoft word, Microsoft excel, Microsoft access and Micr...
متن کاملEvaluating a healthcare data warehouse for cancer diseases
This paper presents the evaluation of the architecture of healthcare data warehouse specific to cancer diseases. This data warehouse containing relevant cancer medical information and patient data. The data warehouse provides the source for all current and historical health data to help executive manager and doctors to improve the decision making process for cancer patients. The evaluation mode...
متن کاملEvaluation of the Microsoft office familiarity of the medical students of Hormozgan Medical University in 2006
The ability to access, evaluate and use information in each profession is one of the most effective materials of individual success. Accessing updated medical information is vital for physicians (1-5). In a descriptive cross sectional study performed in Bandar Abbas, the capital city of Hormozgan province in the southern part of Iran. Data the internet and computer usage was examined among m...
متن کامل